﻿CREATE TABLE [Core].[Message] (
    [MessageId]      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [BusinessUnitId] UNIQUEIDENTIFIER NOT NULL,
    [PluginId]       UNIQUEIDENTIFIER NOT NULL,
    [ContactId]      UNIQUEIDENTIFIER NOT NULL,
    [Subject]        NVARCHAR (127)   NOT NULL,
    [MessageText]    NVARCHAR (1000)  NOT NULL,
    [ReplyToId]      UNIQUEIDENTIFIER NULL,
    [IsDroppedYN]    NCHAR (1)        NOT NULL,
    [CreateDT]       DATETIME         NOT NULL
);

